﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_COM_PGM_ACCESS_LOG_Insert')
	BEGIN
		DROP Procedure usp_UPDMS_COM_PGM_ACCESS_LOG_Insert
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_COM_PGM_ACCESS_LOG_Insert
**	Desc : 접속로그를 Insert한다.
**	Test Exec Query : Exec usp_UPDMS_COM_PGM_ACCESS_LOG_Insert
**	Called by : Base.Dac.AccessCheck.cs
**	Program ID : AnyWhere
**	Auth : 송시명
**	Date : 2013-06-19
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_COM_PGM_ACCESS_LOG_Insert]
@User_Id nvarchar(20),
@Lang_Set nvarchar(2),
@User_Ip varchar(50),
@Server_Ip varchar(50),
@Browser_Nm nvarchar(200),
@Browser_Ver nvarchar(10),
@Pgm_Id nvarchar(20)
AS
SET NOCOUNT OFF

INSERT INTO UPDMS_COM_PGM_ACCESS_LOG (
       User_Id,
       Lang_Set,
       User_Ip,
       Server_Ip,
       Browser_Nm,
       Browser_Ver,
       Pgm_Id,
       Access_Dt
)
VALUES (
       @User_Id,
       @Lang_Set,
       @User_Ip,
       @Server_Ip,
       @Browser_Nm,
       @Browser_Ver,
       @Pgm_Id,
       GETDATE()
)

GO